Project Effort Grouped by Month
This article provides all the Fields available for each View currently available under the Project Effort Grouped by Month Data Source in Upland Analytics.
The following Views are available when Project Effort Grouped by Month Data Source is selected upon creating a report. Click on any of them to view the available Fields.
Actual Allocated Project Monthly Time
Actual Allocated Project Monthly Time
| Field Name | Description | Type |
| Actual Allocated Project Monthly Time Actual Effort Cost | This is the actual effort cost. | # |
| Actual Allocated Project Monthly Time Actual Effort Hours | This is the actual effort in hours. | # |
| Actual Allocated Project Monthly Time Allocated Effort Cost | This is the allocated effort cost. | # |
| Actual Allocated Project Monthly Time Allocated Effort | This is the allocated effort in hours. | # |
| Actual Allocated Project Monthly Time Date | This is the date. |
|
| Actual Allocated Project Monthly Time Project Id | This is the ID of a project. | A |
| Actual Allocated Project Monthly Time Time Status | This is the time status. | A |
| Actualallocatedprojectmonthlytime Date Month Year | This is the date reported as (Month Year). |
|
| Actualallocatedprojectmonthlytime Date Quarter Year | This is the date reported as (Year Quarter). |
|
| Actualallocatedprojectmonthlytime Date Year | This is the date reported as (Year). |
|
| Field Name | Description | Type |
| Created By | The user ID of the user who created the Project's Portfolio. | A |
| Created Date | The date the Project's Portfolio was created, formatted mm/dd/yyyy with a timestamp. |
|
| Created Date Month Year | The month and year the Project's Portfolio was created. |
|
| Created Date Quarter Year | The financial quarter and year the Project's Portfolio was created. |
|
| Created Date Year | The year the Project's Portfolio was created. |
|
| Portfolio Id | This is the id of the portfolio. | A |
| Modified By | The user ID of the user who last modified the Project's Portfolio. |
|
| Modified Date | The date the Project's Portfolio was last modified, formatted mm/dd/yyyy with a timestamp. |
|
| Modified Date Month Year | The month and year the Project's Portfolio was last modified. |
|
| Modified Date Quarter Year | The financial quarter and year the Project's Portfolio was last modified. |
|
| Modified Date Year | The year the Project's Portfolio was last modified. | A |
| Portfolio Name | This is the name of the portfolio. | A |
| Field Name | Description | Type |
| Created By | This is the project's program creator ID. | A |
| Created Date | The date the Program was created, formatted as mm/dd/yyyy with a timestamp. |
|
| Created Date Date | The date the Program was created, formatted as mm/dd/yyyy without a timestamp. |
|
| Created Date Month Year | The month and the year that the Program was created. |
|
| Created Date Quarter Year | The fiscal quarter and the year that the Program was created. |
|
| Created Date Year | The year that the Program was created. |
|
| Created Date Week | The week that the Program was created. |
|
| Description | This is the program description. | A |
| Modified By | This is the program modifier. | A |
| Modified Date | The date the Program was last modified, formatted as mm/dd/yyyy with a timestamp. |
|
| Modified Date Date | The date the Program was last modified, formatted as mm/dd/yyyy without a timestamp. |
|
| Modified Date Month Year | The month and the year that the Program was last modified. |
|
| Modified Date Quarter Year | The fiscal quarter and the year that the Program was last modified. |
|
| Modified Date Year | The year that the Program was last modified. |
|
| Modified Date Week | The week that the Program was last modified. |
|
| Name (Text) | This is the program name. | A |
| Name (URL) | This is the URL link to the program. | A |
| Number | This is the program number. | # |
| Organization Owner | This is the organization owner. | A |
| Owner | This is the program owner. | A |
| Portfolio | This is the name of the portfolio associated to the program. | A |
| Program Id | This is the Id of the program. | A |
| Program Last Status Update | The date (mm/dd/yyyy) and time the Program's Status Update was last modified. This only refers to the Status Update, not the Status or any Health Indicators. |
|
| Program Last Status Update Week | The week the Program's Status Update was last modified. This only refers to the Status Update, not the Status or any Health Indicators. |
|
| Status | This is the status of the program. | A |
| Program Status Update | The Program's current Status Update (not to be confused with Status). | A |
| Status Type | This is the status type of the program. | A |
| Status Type Id | This is the status type Id of the program. | A |
| Field Name | Description | Type |
| Business Priority | This is the project business priority. | A |
| Category | This is the project category. | A |
| Category Sort Order | This is the project category sort order. | A |
| Created By | Project creator ID. | A |
| Created Date | The date the Project was created, formatted as mm/dd/yyyy with a timestamp. |
|
| Created Date Date | The date the Project was created, formatted as mm/dd/yyyy without a timestamp. |
|
| Created Date Month Year | The month and the year the Project was created. |
|
| Created Date Quarter Year | The fiscal quarter and the year the Project was created. |
|
| Created Date Year | The year the Project was created. |
|
| Created Date Week | The week the Project was created. |
|
| Description | This is the project description. | A |
| Last Status Update | This is the date and time of the project's last status update. |
|
| Modified By | This is the project modifier. | A |
| Modified Date | The date the Project was last modified, formatted as mm/dd/yyyy with a timestamp. |
|
| Modified Date Date | The date the Project was last modified, formatted as mm/dd/yyyy without a timestamp. |
|
| Modified Date Month Year | The month and the year the Project was last modified. |
|
| Modified Date Quarter Year | The fiscal quarter and the year the Project was last modified. |
|
| Modified Date Year | The year the Project was last modified. |
|
| Modified Date Week | The week the Project was last modified. |
|
| Name (Text) | This is the project name. | A |
| Name (URL) | This is the project name. It links directly to the project summary page. | A |
| Number | This is the project number. | A |
| Operations | This is the project operation. | A |
| Organization Owner | This is the project organization owner. | A |
| Owner Id | This is the Id of the owner. | A |
| Portfolio | This is the name of the portfolio associated to the project. | A |
| Priority | This is the project priority. | A |
| Priority Sort Order | This is the project priority sort order. | A |
| Program | This is the name of the program. | A |
| Project Id | This is the ID number of the project. | A |
| Project Status Id | This is the ID number of the project's current status. | |
| Status | This is the current project status. | |
| Status Id | This is the ID number of the project's current status. | A |
| Status Sort Order | This is the where the project's current status is listed in the status sort order. | A |
| Status Type | This is the project status type. | A |
| Status Type Id | This is the ID number of the project's status type. | A |
| Status Update | This is the project's most recent status update. Note that this could take up a lot of space in the report. | A |
| Type | This is the project's type. | A |
| Field Name | Description | Type |
| Abbreviation | The abbreviation of the Project's Organization Unit. | A |
| Created By | The ID number of the user who created the Organization Unit. | A |
| Created Date | The date the Project's Organization Unit was created, formatted mm/dd/yyyy with a timestamp. |
|
| Created Date Month Year | The month and year the Project's Organization Unitwas created. |
|
| Created Date Quarter Year | The financial quarter and year the Project's Organization Unitwas created. |
|
| Created Date Year | The year the Project's Organization Unit was created. |
|
| Modified By | The user ID of the user who last modified the Project's Organization Unit. |
|
| Modified Date | The date the Project's Organization Unit was last modified, formatted mm/dd/yyyy with a timestamp. |
|
| Modified Date Month Year | The month and year the Project's Organization Unit was last modified. |
|
| Modified Date Quarter Year | The financial quarter and year the Project's Organization Unit was last modified. |
|
| Modified Date Year | The year the Project's Organization Unit was last modified. | A |
| Name | The name of the Project's Organization Unit. | A |
| Field Name | Description | Type |
| Created Date Month Year | The month and year the Project Owner's Resource profile was created. |
|
| Created Date Quarter Year | The financial quarter and year the Project Owner's Resource profile was created. |
|
| Created Date Year | The year the Project Owner's Resource profile was created. |
|
| This is the email of the Project owner. | A | |
| Full Name [First Last] | The full name of the Project Owner, with the first name before the last name. | A |
| First Name | This is the first name of the Project owner. | A |
| Full Name [Last First] | The full name of the Project Owner, with the last name before the first name. | A |
| Name [Last First] (URL) | The full name of the Project Owner, with the last name before the first name. The field will link to the Project Owner's Resource profile. | A |
| Last Name | This is the last name of the Project owner. | A |
| Modified Date Month Year | The month and year the Project Owner's Resource profile was last modified. |
|
| Modified Date Quarter Year | The financial quarter and year the Project Owner's Resource profile was last modified. |
|
| Modified Date Year | The year the Project Owner's Resource profile was last modified. |
|
| Resource Id | This is the resource Id of the Project owner. | A |
| Status | This is the status of the Project owner. | A |
| Name [First Last] (URL) | The full name of the Project Owner, with the first name before the last name. The field will link to the Project Owner's Resource profile. | A |
| Field Name | Description | Type |
| User Account Type | This is the account type of the user. | A |
| User Chat Id | This is the Chat ID of the user. | A |
| User Created By | This is the ID of the user's creator. | # |
| User Created Date | This is the date the user was created. | A |
| User Email | This is the email of the user. | A |
| User Employee Id | This is the employee ID of the user. | A |
| User Ext | This is the phone number extension of the user. | A |
| User Fax | This is the fax number of the user. | A |
| User First Name | This is the first name of the user. | A |
| User First Last Name | The full name of the user, with the first name before the last name. | A |
| User Handle | This is the "@" handle of the user. | A |
| User Id | This is the ID of the user. | # |
| User Initials | These are the initials of the user. | A |
| User Is Active | This indicates whether or not the user is active. | A |
| User Last First Name | The full name of the user, with the first last name before the first name. | A |
| User Last First URL | The full name of the user, with the first last name before the first name. The field will link to the user's profile. | A |
| User Last Name | This is the last name of the user. | A |
| User Login | This is the login email address of the user. | A |
| User Modified By | This is the ID of the last modifier of the user. | # |
| User Modified Date | This is the date the user was last modified. | A |
| User Phone | This is the phone number of the user. | A |
| User URL | This is the full name of the user, which is also a link to the user's profile. | A |